﻿CREATE TABLE [Reporting].[LogType]
(
	[LogTypeID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [LOG_LogType_LogTypeID] PRIMARY KEY, 
	[Enum] NVARCHAR(250) NOT NULL CONSTRAINT [LOG_LogType_Enum] UNIQUE,
	[EnumDesc] NVARCHAR(500) NOT NULL CONSTRAINT [LOG_LogType_Description] DEFAULT ('NONE'),
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [LOG_LogType_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [LOG_LogType_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [LOG_LogType_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [LOG_LogType_VersionDate] DEFAULT GETDATE()
)